package com.bci.pwtz.mysql.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.bci.pwtz.mysql.model.UserCompanyRef;

public interface UserCompanyRefMapper {
    int deleteByPrimaryKey(Long refId);

    int insert(UserCompanyRef record);

    int insertSelective(UserCompanyRef record);

    UserCompanyRef selectByPrimaryKey(Long refId);

    int updateByPrimaryKeySelective(UserCompanyRef record);

    int updateByPrimaryKey(UserCompanyRef record);
    
    List<UserCompanyRef> selectUserCompanyRefList(@Param("userId")Long userId);
    
    int deleteRef(@Param("userId")Long userId,@Param("companyId")Long companyId);
    
    int selectJoinCompanyNumByUserId(@Param("userId")Long userId);
    
    int selectInCompany(@Param("userId")Long userId,@Param("companyId")Long companyId);
    
    int selectCompanyUsers(@Param("companyId")Long companyId);
    
    List<UserCompanyRef> userStatics(@Param("begintime")String begintime,@Param("endtime")String endtime,@Param("companyName")String companyName);
    
    List<UserCompanyRef> selectCompanyUserList(@Param("companyId")Long companyId,@Param("beginIndex")int beginIndex,@Param("pageSize")int pageSize);
}